|
|
|
|
- Linear amortization
- Managing errors
FinLinearRedemption (Function) In french: FinAmortissementLinéaire Calculates the value of linear amortization of a product over a specific period of time.
// Amortization value of a product bought for 25000 Euros whose // residual value will be 15000 Euros after 6 years. ResAmortization = FinLinearRedemption(25000, 15000, 6)
Syntax
<Result> = FinLinearRedemption(<Acquisition cost> , <Residual value> , <Duration>)
<Result>: Real or currency - Value of amortization,
- 0 is the amortization is null.
<Acquisition cost>: Real or currency Acquisition cost of the product. <Residual value>: Real or currency Residual value of the product after amortization. <Duration>: Real Number of periods during which the product is repaid. This duration cannot be null. Remarks In a linear amortization, the amortization value is the same for each amortization period. Caution: FinLinearRedemption returns no error code. To determine if this function has generated errors, use FinError. To get more details on the error, use ErrorInfo with the errMessage constant.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|